In Calgary it is usually water management outside the house, not a failing foundation — which is good news, because outside is cheap to fix.
The ground should slope away from the house on every side, noticeably, for several feet. If you stand at the wall and the ground is flat or tilts back toward the foundation, that is the problem — and it is very common on homes twenty years and older, because soil settles.
Check for it yourself on any viewing. It takes thirty seconds per side and it is one of the few genuinely useful things a buyer can assess without an inspector.
Not universally. A sump pump collects water from the weeping tile around the foundation and pumps it away, and whether one is needed depends on the site, the water table and how the home was built. Plenty of Calgary homes have none and stay dry.
If a home has one, ask two things: does it work, and is there a backup. A sump pump that fails during a spring melt or a power cut is precisely when it was needed. Battery backups exist and are inexpensive relative to a finished basement.
A finished basement can conceal all of this. That is not sinister — people finish basements — but it is why an inspection matters more in a finished basement, not less.